
Use Tunga

GO
--Insert
CREATE PROC insertCity
	@[id] int,
	@name int
AS
INSERT INTO  [City]([name])
 VALUES(@name)

GO
--Update
CREATE PROC updateCity
	@[id] int,
	@name int
AS
UPDATE [City] SET	
	[name] =@name
WHERE 	[id] =@[id]
GO
--Delete
CREATE PROC deleteCity
	@[id] int
AS
	DELETE FROM [City] WHERE [id]=@[id]
GO
--Get All City
CREATE PROC getAllCity
AS
SELECT * from [City]
GO
--Get City By ID
CREATE PROC getCityByID
	@[id] int
AS
SELECT * from [City] WHERE [id]=@[id]
GO


